CREATE procedure [dbo].[BAEEventGetList] @showAll int,
     @city varchar(40),
     @date varchar(20) as
     declare @justdate datetime
    set @justdate = DATEADD(dd,(DATEDIFF(dd,0,@date)),0)
if(@showAll=1 AND @city <> ''  AND @date <> '')
        SELECT *
        FROM Meet_Master
        WHERE CITY = @city AND BEGIN_DATE = @date AND  WEB_ENABLED = '1' AND (DATEADD(dd,(DATEDIFF(dd,0,BEGIN_DATE)),0) >= @justdate OR DATEADD(dd,(DATEDIFF(dd,0,END_DATE)),0) >= @justdate)
        ORDER BY BEGIN_DATE;
    else if(@showAll = 1 AND @city <>'')
        SELECT *
        FROM Meet_Master
        WHERE CITY = @city AND WEB_ENABLED = '1' AND (DATEADD(dd,(DATEDIFF(dd,0,BEGIN_DATE)),0) >= @justdate OR DATEADD(dd,(DATEDIFF(dd,0,END_DATE)),0) >= @justdate)
        ORDER BY BEGIN_DATE;
    else if(@showAll = 1 AND @date <> '')
        SELECT *
        FROM Meet_Master
        WHERE BEGIN_DATE = @date AND WEB_ENABLED = '1' AND (DATEADD(dd,(DATEDIFF(dd,0,BEGIN_DATE)),0) >= @justdate OR DATEADD(dd,(DATEDIFF(dd,0,END_DATE)),0) >= @justdate)
        ORDER BY BEGIN_DATE;
    else if(@showAll = 1)
        SELECT *
        FROM Meet_Master
        WHERE  WEB_ENABLED = '1' AND (DATEADD(dd,(DATEDIFF(dd,0,BEGIN_DATE)),0) >= @justdate OR DATEADD(dd,(DATEDIFF(dd,0,END_DATE)),0) >= @justdate)
        ORDER BY BEGIN_DATE;
    else if(@date <> ''  AND @city <> '')    
        SELECT *
        FROM Meet_Master
        WHERE WEB_ENABLED = '1' AND STATUS = 'A' AND CITY = @city AND BEGIN_DATE = @date  AND (DATEADD(dd,(DATEDIFF(dd,0,BEGIN_DATE)),0) >= @justdate OR DATEADD(dd,(DATEDIFF(dd,0,END_DATE)),0) >= @justdate)
        ORDER BY BEGIN_DATE;
    else if(@date <> '')
        SELECT *
        FROM Meet_Master
        WHERE WEB_ENABLED = '1' AND STATUS = 'A' AND BEGIN_DATE = @date  AND (DATEADD(dd,(DATEDIFF(dd,0,BEGIN_DATE)),0) >=@justdate OR DATEADD(dd,(DATEDIFF(dd,0,END_DATE)),0) >= @justdate)
        ORDER BY  BEGIN_DATE;
    else if(@city <> '')
        SELECT *
        FROM Meet_Master
        WHERE WEB_ENABLED = '1' AND STATUS = 'A' AND CITY = @city  AND (DATEADD(dd,(DATEDIFF(dd,0,BEGIN_DATE)),0) >= @justdate OR DATEADD(dd,(DATEDIFF(dd,0,END_DATE)),0) >= @justdate)
        ORDER BY BEGIN_DATE;
    else
        SELECT *
        FROM Meet_Master
        WHERE WEB_ENABLED = '1' AND STATUS = 'A'  AND (DATEADD(dd,(DATEDIFF(dd,0,BEGIN_DATE)),0) >= @justdate OR DATEADD(dd,(DATEDIFF(dd,0,END_DATE)),0) >= @justdate)
        ORDER BY BEGIN_DATE;

GO